package com.bluecat.config;

import java.sql.SQLException;

import javax.sql.DataSource;

import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Primary;
import org.springframework.context.annotation.PropertySource;

import com.alibaba.druid.pool.DruidDataSource;

@ConfigurationProperties(prefix = "spring.datasource")
@PropertySource("classpath:/config/datasource.yml")
public class DatasourceConfig {

    private String url;

    private String username;
    
    private String password;

    private String driverClassName;

    private int initialSize;

    private int minIdle;

    private int maxActive;

    private int maxWait;

    private int timeBetweenEvictionRunsMillis;

    private int minEvictableIdleTimeMillis;

    private String validationQuery;

    private boolean testWhileIdle;

    private boolean testOnBorrow;

    private boolean testOnReturn;

    private boolean poolPreparedStatements;

    private int maxPoolPreparedStatementPerConnectionSize;

    private String filters;

    private String connectionProperties;
    
    private boolean useGlobalDataSourceStat;
    
    @Bean
    @Primary
    public DataSource dataSource() {
        DruidDataSource datasource = new DruidDataSource();
 
        datasource.setUrl(url);
        datasource.setUsername(username);
        datasource.setPassword(password);   //这里可以做加密处理
        datasource.setDriverClassName(driverClassName);
 
        //configuration
        datasource.setInitialSize(initialSize);
        datasource.setMinIdle(minIdle);
        datasource.setMaxActive(maxActive);
        datasource.setMaxWait(maxWait);
        datasource.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);
        datasource.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);
        datasource.setValidationQuery(validationQuery);
        datasource.setTestWhileIdle(testWhileIdle);
        datasource.setTestOnBorrow(testOnBorrow);
        datasource.setTestOnReturn(testOnReturn);
        datasource.setPoolPreparedStatements(poolPreparedStatements);
        datasource.setMaxPoolPreparedStatementPerConnectionSize(maxPoolPreparedStatementPerConnectionSize);
        datasource.setUseGlobalDataSourceStat(useGlobalDataSourceStat);
        try {
            datasource.setFilters(filters);
        } catch (SQLException e) {
 
        }
        datasource.setConnectionProperties(connectionProperties);
 
        return datasource;
    }
 
 
	/*
	 * @Bean public ServletRegistrationBean<StatViewServlet> druidServlet() {
	 * log.info("init Druid Servlet Configuration ");
	 * ServletRegistrationBean<StatViewServlet> servletRegistrationBean = new
	 * ServletRegistrationBean<StatViewServlet>(new StatViewServlet(), "/druid/*");
	 * // IP白名单 // servletRegistrationBean.addInitParameter("allow",
	 * "192.168.2.25,127.0.0.1"); // IP黑名单(共同存在时，deny优先于allow)
	 * //servletRegistrationBean.addInitParameter("deny", "192.168.1.100");
	 * //控制台管理用户 servletRegistrationBean.addInitParameter("loginUsername", "admin");
	 * servletRegistrationBean.addInitParameter("loginPassword", "9527"); //是否能够重置数据
	 * 禁用HTML页面上的“Reset All”功能
	 * servletRegistrationBean.addInitParameter("resetEnable", "false"); return
	 * servletRegistrationBean; }
	 * 
	 * @Bean public FilterRegistrationBean<WebStatFilter> filterRegistrationBean() {
	 * FilterRegistrationBean<WebStatFilter> filterRegistrationBean = new
	 * FilterRegistrationBean<WebStatFilter>(new WebStatFilter());
	 * filterRegistrationBean.addUrlPatterns("/*");
	 * filterRegistrationBean.addInitParameter("exclusions",
	 * "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*"); return
	 * filterRegistrationBean; }
	 */

}
